Release 10.1A: OpenEdge Deployment:
Startup Command and Parameter Reference

Schema Field Cache Size (-fc)

Use Schema Field Cache Size (-fc) to change the number of entries in the schema field cache.

Operating system and syntax	UNIX Windows	-fc num-entries
Use with	Maximum value	Minimum value	Single-user default	Multi-user default
Client Session	–	0	128	128

num-entries

The number of entries in the schema field cache.

For example, you might increase the size if you retrieve large numbers of fields from your database. The Progress schema field cache reduces the time required to compile SQL queries by storing schema field information in memory. For best results, set this parameter to the total number of fields retrieved from the database.

Progress uses approximately 150 additional bytes of memory per schema field cache entry used. Because memory is allocated when required, unused entries produce minimal overhead.

If you set the value to 0, Progress disables schema field caching.